﻿using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using HYSoft.IDAL;
using HYSoft.DBUtility;//Please add references
namespace HYSoft.SQLServerDAL
{
	/// <summary>
	/// 数据访问类:bppmzbinfo
	/// </summary>
	public partial class bppmzbinfo:Ibppmzbinfo
	{
		public bppmzbinfo()
		{}
		#region  BasicMethod

		/// <summary>
		/// 得到最大ID
		/// </summary>
		public int GetMaxId()
		{
		return DbHelperSQL.GetMaxID("cdbh", "tb_bppmzbinfo"); 
		}

		/// <summary>
		/// 是否存在该记录
		/// </summary>
		public bool Exists(int cdbh,int ljbp_sec_id)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) from tb_bppmzbinfo");
			strSql.Append(" where cdbh=@cdbh and ljbp_sec_id=@ljbp_sec_id ");
			SqlParameter[] parameters = {
					new SqlParameter("@cdbh", SqlDbType.Int,4),
					new SqlParameter("@ljbp_sec_id", SqlDbType.Int,4)			};
			parameters[0].Value = cdbh;
			parameters[1].Value = ljbp_sec_id;

			return DbHelperSQL.Exists(strSql.ToString(),parameters);
		}


		/// <summary>
		/// 增加一条数据
		/// </summary>
		public bool Add(HYSoft.Model.bppmzbinfo model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into tb_bppmzbinfo(");
			strSql.Append("cdbh,ljbp_sec_id,cdzb_x,cdzb_y,cdzb_z,ljbpzksd,cdcgqsl,cdcgqclsd1,cdcgqclsd2,cdcgqclsd3,cdcgqclsd4,cdcgqclsd5,cdcgqclsd6,cdcgqclsd7,cdcgqclsd8,cdcgqclsd9,cdcgqclsd10,cdcgqclsd11,cdcgqclsd12,cdcgqclsd13,cdcgqclsd14,cdcgqclsd15,cdcgqclsd16,cdcgqclsd17,cdcgqclsd18,cdcgqclsd19,cdcgqclsd20)");
			strSql.Append(" values (");
			strSql.Append("@cdbh,@ljbp_sec_id,@cdzb_x,@cdzb_y,@cdzb_z,@ljbpzksd,@cdcgqsl,@cdcgqclsd1,@cdcgqclsd2,@cdcgqclsd3,@cdcgqclsd4,@cdcgqclsd5,@cdcgqclsd6,@cdcgqclsd7,@cdcgqclsd8,@cdcgqclsd9,@cdcgqclsd10,@cdcgqclsd11,@cdcgqclsd12,@cdcgqclsd13,@cdcgqclsd14,@cdcgqclsd15,@cdcgqclsd16,@cdcgqclsd17,@cdcgqclsd18,@cdcgqclsd19,@cdcgqclsd20)");
			SqlParameter[] parameters = {
					new SqlParameter("@cdbh", SqlDbType.Int,4),
					new SqlParameter("@ljbp_sec_id", SqlDbType.Int,4),
					new SqlParameter("@cdzb_x", SqlDbType.Float,8),
					new SqlParameter("@cdzb_y", SqlDbType.Float,8),
					new SqlParameter("@cdzb_z", SqlDbType.Float,8),
					new SqlParameter("@ljbpzksd", SqlDbType.Int,4),
					new SqlParameter("@cdcgqsl", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd1", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd2", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd3", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd4", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd5", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd6", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd7", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd8", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd9", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd10", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd11", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd12", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd13", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd14", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd15", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd16", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd17", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd18", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd19", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd20", SqlDbType.Int,4)};
			parameters[0].Value = model.cdbh;
			parameters[1].Value = model.ljbp_sec_id;
			parameters[2].Value = model.cdzb_x;
			parameters[3].Value = model.cdzb_y;
			parameters[4].Value = model.cdzb_z;
			parameters[5].Value = model.ljbpzksd;
			parameters[6].Value = model.cdcgqsl;
			parameters[7].Value = model.cdcgqclsd1;
			parameters[8].Value = model.cdcgqclsd2;
			parameters[9].Value = model.cdcgqclsd3;
			parameters[10].Value = model.cdcgqclsd4;
			parameters[11].Value = model.cdcgqclsd5;
			parameters[12].Value = model.cdcgqclsd6;
			parameters[13].Value = model.cdcgqclsd7;
			parameters[14].Value = model.cdcgqclsd8;
			parameters[15].Value = model.cdcgqclsd9;
			parameters[16].Value = model.cdcgqclsd10;
			parameters[17].Value = model.cdcgqclsd11;
			parameters[18].Value = model.cdcgqclsd12;
			parameters[19].Value = model.cdcgqclsd13;
			parameters[20].Value = model.cdcgqclsd14;
			parameters[21].Value = model.cdcgqclsd15;
			parameters[22].Value = model.cdcgqclsd16;
			parameters[23].Value = model.cdcgqclsd17;
			parameters[24].Value = model.cdcgqclsd18;
			parameters[25].Value = model.cdcgqclsd19;
			parameters[26].Value = model.cdcgqclsd20;

			int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		/// <summary>
		/// 更新一条数据
		/// </summary>
		public bool Update(HYSoft.Model.bppmzbinfo model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update tb_bppmzbinfo set ");
			strSql.Append("cdzb_x=@cdzb_x,");
			strSql.Append("cdzb_y=@cdzb_y,");
			strSql.Append("cdzb_z=@cdzb_z,");
			strSql.Append("ljbpzksd=@ljbpzksd,");
			strSql.Append("cdcgqsl=@cdcgqsl,");
			strSql.Append("cdcgqclsd1=@cdcgqclsd1,");
			strSql.Append("cdcgqclsd2=@cdcgqclsd2,");
			strSql.Append("cdcgqclsd3=@cdcgqclsd3,");
			strSql.Append("cdcgqclsd4=@cdcgqclsd4,");
			strSql.Append("cdcgqclsd5=@cdcgqclsd5,");
			strSql.Append("cdcgqclsd6=@cdcgqclsd6,");
			strSql.Append("cdcgqclsd7=@cdcgqclsd7,");
			strSql.Append("cdcgqclsd8=@cdcgqclsd8,");
			strSql.Append("cdcgqclsd9=@cdcgqclsd9,");
			strSql.Append("cdcgqclsd10=@cdcgqclsd10,");
			strSql.Append("cdcgqclsd11=@cdcgqclsd11,");
			strSql.Append("cdcgqclsd12=@cdcgqclsd12,");
			strSql.Append("cdcgqclsd13=@cdcgqclsd13,");
			strSql.Append("cdcgqclsd14=@cdcgqclsd14,");
			strSql.Append("cdcgqclsd15=@cdcgqclsd15,");
			strSql.Append("cdcgqclsd16=@cdcgqclsd16,");
			strSql.Append("cdcgqclsd17=@cdcgqclsd17,");
			strSql.Append("cdcgqclsd18=@cdcgqclsd18,");
			strSql.Append("cdcgqclsd19=@cdcgqclsd19,");
			strSql.Append("cdcgqclsd20=@cdcgqclsd20");
			strSql.Append(" where cdbh=@cdbh and ljbp_sec_id=@ljbp_sec_id ");
			SqlParameter[] parameters = {
					new SqlParameter("@cdzb_x", SqlDbType.Float,8),
					new SqlParameter("@cdzb_y", SqlDbType.Float,8),
					new SqlParameter("@cdzb_z", SqlDbType.Float,8),
					new SqlParameter("@ljbpzksd", SqlDbType.Int,4),
					new SqlParameter("@cdcgqsl", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd1", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd2", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd3", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd4", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd5", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd6", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd7", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd8", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd9", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd10", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd11", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd12", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd13", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd14", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd15", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd16", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd17", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd18", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd19", SqlDbType.Int,4),
					new SqlParameter("@cdcgqclsd20", SqlDbType.Int,4),
					new SqlParameter("@cdbh", SqlDbType.Int,4),
					new SqlParameter("@ljbp_sec_id", SqlDbType.Int,4)};
			parameters[0].Value = model.cdzb_x;
			parameters[1].Value = model.cdzb_y;
			parameters[2].Value = model.cdzb_z;
			parameters[3].Value = model.ljbpzksd;
			parameters[4].Value = model.cdcgqsl;
			parameters[5].Value = model.cdcgqclsd1;
			parameters[6].Value = model.cdcgqclsd2;
			parameters[7].Value = model.cdcgqclsd3;
			parameters[8].Value = model.cdcgqclsd4;
			parameters[9].Value = model.cdcgqclsd5;
			parameters[10].Value = model.cdcgqclsd6;
			parameters[11].Value = model.cdcgqclsd7;
			parameters[12].Value = model.cdcgqclsd8;
			parameters[13].Value = model.cdcgqclsd9;
			parameters[14].Value = model.cdcgqclsd10;
			parameters[15].Value = model.cdcgqclsd11;
			parameters[16].Value = model.cdcgqclsd12;
			parameters[17].Value = model.cdcgqclsd13;
			parameters[18].Value = model.cdcgqclsd14;
			parameters[19].Value = model.cdcgqclsd15;
			parameters[20].Value = model.cdcgqclsd16;
			parameters[21].Value = model.cdcgqclsd17;
			parameters[22].Value = model.cdcgqclsd18;
			parameters[23].Value = model.cdcgqclsd19;
			parameters[24].Value = model.cdcgqclsd20;
			parameters[25].Value = model.cdbh;
			parameters[26].Value = model.ljbp_sec_id;

			int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}

		/// <summary>
		/// 删除一条数据
		/// </summary>
		public bool Delete(int cdbh,int ljbp_sec_id)
		{
			
			StringBuilder strSql=new StringBuilder();
			strSql.Append("delete from tb_bppmzbinfo ");
			strSql.Append(" where cdbh=@cdbh and ljbp_sec_id=@ljbp_sec_id ");
			SqlParameter[] parameters = {
					new SqlParameter("@cdbh", SqlDbType.Int,4),
					new SqlParameter("@ljbp_sec_id", SqlDbType.Int,4)			};
			parameters[0].Value = cdbh;
			parameters[1].Value = ljbp_sec_id;

			int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}


		/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public HYSoft.Model.bppmzbinfo GetModel(int cdbh,int ljbp_sec_id)
		{
			
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select  top 1 cdbh,ljbp_sec_id,cdzb_x,cdzb_y,cdzb_z,ljbpzksd,cdcgqsl,cdcgqclsd1,cdcgqclsd2,cdcgqclsd3,cdcgqclsd4,cdcgqclsd5,cdcgqclsd6,cdcgqclsd7,cdcgqclsd8,cdcgqclsd9,cdcgqclsd10,cdcgqclsd11,cdcgqclsd12,cdcgqclsd13,cdcgqclsd14,cdcgqclsd15,cdcgqclsd16,cdcgqclsd17,cdcgqclsd18,cdcgqclsd19,cdcgqclsd20 from tb_bppmzbinfo ");
			strSql.Append(" where cdbh=@cdbh and ljbp_sec_id=@ljbp_sec_id ");
			SqlParameter[] parameters = {
					new SqlParameter("@cdbh", SqlDbType.Int,4),
					new SqlParameter("@ljbp_sec_id", SqlDbType.Int,4)			};
			parameters[0].Value = cdbh;
			parameters[1].Value = ljbp_sec_id;

			HYSoft.Model.bppmzbinfo model=new HYSoft.Model.bppmzbinfo();
			DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
			if(ds.Tables[0].Rows.Count>0)
			{
				return DataRowToModel(ds.Tables[0].Rows[0]);
			}
			else
			{
				return null;
			}
		}


		/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public HYSoft.Model.bppmzbinfo DataRowToModel(DataRow row)
		{
			HYSoft.Model.bppmzbinfo model=new HYSoft.Model.bppmzbinfo();
			if (row != null)
			{
				if(row["cdbh"]!=null && row["cdbh"].ToString()!="")
				{
					model.cdbh=int.Parse(row["cdbh"].ToString());
				}
				if(row["ljbp_sec_id"]!=null && row["ljbp_sec_id"].ToString()!="")
				{
					model.ljbp_sec_id=int.Parse(row["ljbp_sec_id"].ToString());
				}
				if(row["cdzb_x"]!=null && row["cdzb_x"].ToString()!="")
				{
					model.cdzb_x=decimal.Parse(row["cdzb_x"].ToString());
				}
				if(row["cdzb_y"]!=null && row["cdzb_y"].ToString()!="")
				{
					model.cdzb_y=decimal.Parse(row["cdzb_y"].ToString());
				}
				if(row["cdzb_z"]!=null && row["cdzb_z"].ToString()!="")
				{
					model.cdzb_z=decimal.Parse(row["cdzb_z"].ToString());
				}
				if(row["ljbpzksd"]!=null && row["ljbpzksd"].ToString()!="")
				{
					model.ljbpzksd=int.Parse(row["ljbpzksd"].ToString());
				}
				if(row["cdcgqsl"]!=null && row["cdcgqsl"].ToString()!="")
				{
					model.cdcgqsl=int.Parse(row["cdcgqsl"].ToString());
				}
				if(row["cdcgqclsd1"]!=null && row["cdcgqclsd1"].ToString()!="")
				{
					model.cdcgqclsd1=int.Parse(row["cdcgqclsd1"].ToString());
				}
				if(row["cdcgqclsd2"]!=null && row["cdcgqclsd2"].ToString()!="")
				{
					model.cdcgqclsd2=int.Parse(row["cdcgqclsd2"].ToString());
				}
				if(row["cdcgqclsd3"]!=null && row["cdcgqclsd3"].ToString()!="")
				{
					model.cdcgqclsd3=int.Parse(row["cdcgqclsd3"].ToString());
				}
				if(row["cdcgqclsd4"]!=null && row["cdcgqclsd4"].ToString()!="")
				{
					model.cdcgqclsd4=int.Parse(row["cdcgqclsd4"].ToString());
				}
				if(row["cdcgqclsd5"]!=null && row["cdcgqclsd5"].ToString()!="")
				{
					model.cdcgqclsd5=int.Parse(row["cdcgqclsd5"].ToString());
				}
				if(row["cdcgqclsd6"]!=null && row["cdcgqclsd6"].ToString()!="")
				{
					model.cdcgqclsd6=int.Parse(row["cdcgqclsd6"].ToString());
				}
				if(row["cdcgqclsd7"]!=null && row["cdcgqclsd7"].ToString()!="")
				{
					model.cdcgqclsd7=int.Parse(row["cdcgqclsd7"].ToString());
				}
				if(row["cdcgqclsd8"]!=null && row["cdcgqclsd8"].ToString()!="")
				{
					model.cdcgqclsd8=int.Parse(row["cdcgqclsd8"].ToString());
				}
				if(row["cdcgqclsd9"]!=null && row["cdcgqclsd9"].ToString()!="")
				{
					model.cdcgqclsd9=int.Parse(row["cdcgqclsd9"].ToString());
				}
				if(row["cdcgqclsd10"]!=null && row["cdcgqclsd10"].ToString()!="")
				{
					model.cdcgqclsd10=int.Parse(row["cdcgqclsd10"].ToString());
				}
				if(row["cdcgqclsd11"]!=null && row["cdcgqclsd11"].ToString()!="")
				{
					model.cdcgqclsd11=int.Parse(row["cdcgqclsd11"].ToString());
				}
				if(row["cdcgqclsd12"]!=null && row["cdcgqclsd12"].ToString()!="")
				{
					model.cdcgqclsd12=int.Parse(row["cdcgqclsd12"].ToString());
				}
				if(row["cdcgqclsd13"]!=null && row["cdcgqclsd13"].ToString()!="")
				{
					model.cdcgqclsd13=int.Parse(row["cdcgqclsd13"].ToString());
				}
				if(row["cdcgqclsd14"]!=null && row["cdcgqclsd14"].ToString()!="")
				{
					model.cdcgqclsd14=int.Parse(row["cdcgqclsd14"].ToString());
				}
				if(row["cdcgqclsd15"]!=null && row["cdcgqclsd15"].ToString()!="")
				{
					model.cdcgqclsd15=int.Parse(row["cdcgqclsd15"].ToString());
				}
				if(row["cdcgqclsd16"]!=null && row["cdcgqclsd16"].ToString()!="")
				{
					model.cdcgqclsd16=int.Parse(row["cdcgqclsd16"].ToString());
				}
				if(row["cdcgqclsd17"]!=null && row["cdcgqclsd17"].ToString()!="")
				{
					model.cdcgqclsd17=int.Parse(row["cdcgqclsd17"].ToString());
				}
				if(row["cdcgqclsd18"]!=null && row["cdcgqclsd18"].ToString()!="")
				{
					model.cdcgqclsd18=int.Parse(row["cdcgqclsd18"].ToString());
				}
				if(row["cdcgqclsd19"]!=null && row["cdcgqclsd19"].ToString()!="")
				{
					model.cdcgqclsd19=int.Parse(row["cdcgqclsd19"].ToString());
				}
				if(row["cdcgqclsd20"]!=null && row["cdcgqclsd20"].ToString()!="")
				{
					model.cdcgqclsd20=int.Parse(row["cdcgqclsd20"].ToString());
				}
			}
			return model;
		}

		/// <summary>
		/// 获得数据列表
		/// </summary>
		public DataSet GetList(string strWhere)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select cdbh,ljbp_sec_id,cdzb_x,cdzb_y,cdzb_z,ljbpzksd,cdcgqsl,cdcgqclsd1,cdcgqclsd2,cdcgqclsd3,cdcgqclsd4,cdcgqclsd5,cdcgqclsd6,cdcgqclsd7,cdcgqclsd8,cdcgqclsd9,cdcgqclsd10,cdcgqclsd11,cdcgqclsd12,cdcgqclsd13,cdcgqclsd14,cdcgqclsd15,cdcgqclsd16,cdcgqclsd17,cdcgqclsd18,cdcgqclsd19,cdcgqclsd20 ");
			strSql.Append(" FROM tb_bppmzbinfo ");
			if(strWhere.Trim()!="")
			{
				strSql.Append(" where "+strWhere);
			}
			return DbHelperSQL.Query(strSql.ToString());
		}

		/// <summary>
		/// 获得前几行数据
		/// </summary>
		public DataSet GetList(int Top,string strWhere,string filedOrder)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select ");
			if(Top>0)
			{
				strSql.Append(" top "+Top.ToString());
			}
			strSql.Append(" cdbh,ljbp_sec_id,cdzb_x,cdzb_y,cdzb_z,ljbpzksd,cdcgqsl,cdcgqclsd1,cdcgqclsd2,cdcgqclsd3,cdcgqclsd4,cdcgqclsd5,cdcgqclsd6,cdcgqclsd7,cdcgqclsd8,cdcgqclsd9,cdcgqclsd10,cdcgqclsd11,cdcgqclsd12,cdcgqclsd13,cdcgqclsd14,cdcgqclsd15,cdcgqclsd16,cdcgqclsd17,cdcgqclsd18,cdcgqclsd19,cdcgqclsd20 ");
			strSql.Append(" FROM tb_bppmzbinfo ");
			if(strWhere.Trim()!="")
			{
				strSql.Append(" where "+strWhere);
			}
			strSql.Append(" order by " + filedOrder);
			return DbHelperSQL.Query(strSql.ToString());
		}

		/// <summary>
		/// 获取记录总数
		/// </summary>
		public int GetRecordCount(string strWhere)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) FROM tb_bppmzbinfo ");
			if(strWhere.Trim()!="")
			{
				strSql.Append(" where "+strWhere);
			}
			object obj = DbHelperSQL.GetSingle(strSql.ToString());
			if (obj == null)
			{
				return 0;
			}
			else
			{
				return Convert.ToInt32(obj);
			}
		}
		/// <summary>
		/// 分页获取数据列表
		/// </summary>
		public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("SELECT * FROM ( ");
			strSql.Append(" SELECT ROW_NUMBER() OVER (");
			if (!string.IsNullOrEmpty(orderby.Trim()))
			{
				strSql.Append("order by T." + orderby );
			}
			else
			{
				strSql.Append("order by T.ljbp_sec_id desc");
			}
			strSql.Append(")AS Row, T.*  from tb_bppmzbinfo T ");
			if (!string.IsNullOrEmpty(strWhere.Trim()))
			{
				strSql.Append(" WHERE " + strWhere);
			}
			strSql.Append(" ) TT");
			strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
			return DbHelperSQL.Query(strSql.ToString());
		}

		/*
		/// <summary>
		/// 分页获取数据列表
		/// </summary>
		public DataSet GetList(int PageSize,int PageIndex,string strWhere)
		{
			SqlParameter[] parameters = {
					new SqlParameter("@tblName", SqlDbType.VarChar, 255),
					new SqlParameter("@fldName", SqlDbType.VarChar, 255),
					new SqlParameter("@PageSize", SqlDbType.Int),
					new SqlParameter("@PageIndex", SqlDbType.Int),
					new SqlParameter("@IsReCount", SqlDbType.Bit),
					new SqlParameter("@OrderType", SqlDbType.Bit),
					new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
					};
			parameters[0].Value = "tb_bppmzbinfo";
			parameters[1].Value = "ljbp_sec_id";
			parameters[2].Value = PageSize;
			parameters[3].Value = PageIndex;
			parameters[4].Value = 0;
			parameters[5].Value = 0;
			parameters[6].Value = strWhere;	
			return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
		}*/

		#endregion  BasicMethod
		#region  ExtensionMethod

		#endregion  ExtensionMethod
	}
}

